Re: two tables selecting fields

<jkmambo@xxxxxxxxx> kirjoitti
viestissä:1127597753.452258.9310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxxxxxxxxxxx>


.

Relevant Pages

  • Re: you have no argument
    ... Did you miss the point that cold reading is just as "accurate" as the person ... But those are the rules agreed on by those who practice science. ... individual lives the All experiences life. ... But it does have a record of success in increasing our understanding of the ...
    (talk.origins)
  • Re: Discussion of von Rads _Genesis: A Commentary_
    ... just to clarify, by "science" here, I am referring only to evolutionary ... uninvolved with His creation versus a God involved and caring intimately ... Science in general, and evolution in particular, has nothing to say about ... I don't know what threads you have been reading, ...
    (talk.origins)
  • Re: And another problem for evolution
    ... Heat given off by the nuclear processes inside, ... literalist reading of the bible indicates. ... *science* sites would answer this. ... None of these reasons for knowing the age of the Earth are "guesses", ...
    (talk.origins)
  • Re: And another problem for evolution
    ... Heat given off by the nuclear processes inside, ... literalist reading of the bible indicates. ... *science* sites would answer this. ... Appearances can be decieving. ...
    (talk.origins)
  • Re: OT:Recording session yesterday
    ... >>> Because there are students that need help in reading skills in all ... When do classroom teachers have time to provide individual remediate ... >> and keep the science class on track? ... They have to deal with reality and help kids to ...
    (rec.audio.opinion)