question for newbie

[PHENONITIN]

Hi,
I have a query nested within a much larger query :



SELECT COUNT(1) FROM table1 X WHERE x.person_uid = person_uid AND car = '401' AND
(TO_DATE(startdate,'YYYYMMDD') BETWEEN COVERAGE_BEGIN_DATE AND coverage_end_date OR
TO_DATE(enddate,'YYYYMMDD') BETWEEN COVERAGE_BEGIN_DATE AND coverage_end_date))



I guess my question really is: If not explicity mentioned, which table does the query pull car, coverage_begin_date and coverage_end_date from ?
The above query is part of a much larger query which is from a table Y which has identical fields.
Any help would be greatly appreciated.
Thanks

 

[r937]

if their table is not explicitly mentioned, the columns are taken from the table they are in

if they are in more than one table, you get an error

r937.com | rudy.ca