Perhaps it is too late in the week, and/or I'm rusty with SQL, but I'm
having difficulty nonetheless.
I want to select all entries of a table like so based on some
qualifications:
select ta1.name from table1 ta1, table2 ta2 where ((ta1.id = ta2.id
and ta2.string = "testing" and ta2.sequence = 1) and (ta1.id = ta2.id and
ta2.string = "testing2" and ta2.sequence = 2))
I implemented my actual query using the exist stuff like so:
select l.nam1 from labus38 l where exists (select a.labus38 from la38_ad10 a where a.LABUS38 = l.eid and a.VARST17 = 'This is a test of the varstring type. This is only a test. If this had been an actual advice string, then it would contain inf' and a.seq = 1) AND exists (select a.labus38 from la38_ad10 a where a.LABUS38 = l.eid and a.VARST17 = 'ormation pertinent to this labuser, but alas it does not.' and a.seq = 2)
Please ignore the long stupid strings...
Now, what I want to know is how do I do this in QUEL? And is there an
easier way to do it in SQL without having to use the exists stuff?
