Hooray for Rachel...
That works...
Thanks
Dick Fey
Rachael Malberg wrote
Subject: [RBASE-L] - RE: Maybe its the weather...
and if you've got alot of data to filter threw Sub-selects can really slow
things down so I like to do...
set var xValues note
select listof(distinct StNumber) into xValues from temp1
Select * from VenPrice where StyleNum in (&xValues)
----- Original Message -----
From: "Dennis McGrath" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, October 22, 2008 2:02 PM
Subject: [RBASE-L] - RE: Maybe its the weather...
Try this
Select * from VenPrice where StyleNum in (select distinct StNumber from
temp1)
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Fey
Sent: Wednesday, October 22, 2008 1:41 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Maybe its the weather...
Yes both text 16 seems kinda wierd.
Gives a "no rows exist or meet the where clause.' error
Dick
Dennis McGrath asked ...
Are the two text fields the same length i.e. TEXT (8) ???
Dennis McGrath
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Fey
Sent: Wednesday, October 22, 2008 12:08 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Maybe its the weather...
This works:
Select StNumber from temp1 where StNumber = 'A1234'
This works:
Select StyleNum from VenPrice where StyleNum = 'A1234'
This DOES NOT work:
Select * from VenPrice where StyleNum in (select StNumber from temp1)
What am I missing?
