Re: RE: Join-question

2002-12-06 Thread Victoria Reznichenko
Hello Joseph, Thursday, December 05, 2002, 8:39:18 PM, you wrote: NJ> Victoria, NJ> I am trying to get the hang of this also. In your statement below you NJ> show, what appears to me, two tables, mytest ( I see this one ) and t1. NJ> Where did table t1 come from? Could you explain your sql a li

Re: Re: JOIN-Question

2002-09-19 Thread Mikhail Entaltsev
Peter Stöcker" <[EMAIL PROTECTED]> To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 19, 2002 11:56 AM Subject: Re: Re: JOIN-Question Hi Mikhail! The query should be released automaticly and it shoulb be something like: SELECT a.

Re: Re: JOIN-Question

2002-09-19 Thread Peter Stöcker
Hi CH! Thanks a lot! That's it! I thought there is no differece between "ON (condition)" and "USING(field)", but there is! Thank you very much! CU, Peter [EMAIL PROTECTED] schrieb am 19.09.02 12:02:58: > Hi Peter, > > pls try this query. but its not tested. > > select t1.name, t1.f1, t1.f

Re: Re: JOIN-Question

2002-09-19 Thread Peter Stöcker
Hi Mikhail! The query should be released automaticly and it shoulb be something like: SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16 I want to have all entries wich fit to the condition. But at this time I don't know weather there is a entry with name="test" or "test2" or not.