two tables selecting fields

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Suppose I have two tables A and B

Table A has fields A1, A2, A3, ... A9
Table B has fields B1, B2, B3, ... B9

I want to select all fields in A and only B3 in table B. I dont want to
list individual fields for A because they are too many I simply want to
use a *.

How do I do this?
I tried this way but they are not working
Select * from A1, B3 from B  
Select *, B3 from A, B  


Re: two tables selecting fields

Ok I have figured out how to do it
select A.*, B.B3 from A, B

Site Timeline