|
|
Posted by Kimmo Laine on 11/03/09 11:28
<jkmambo@gmail.com> kirjoitti
viestissδ:1127597753.452258.9310@o13g2000cwo.googlegroups.com...
> 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
>
Try
SELECT A.*, B.B3 FROM A, B
--
SETI @ Home - Donate your cpu's idle time to science.
Further reading at <http://setiweb.ssl.berkeley.edu/>
Kimmo Laine <antaatulla.sikanautaa@gmail.com.NOSPAM.invalid>
Navigation:
[Reply to this message]
|