Ok, I've had a head cold this last week but it really shouldn't have
affected my brain... I need someone to tell me if this should work:
I have two tables in a database,
ServiceTypes, containing a column, ServiceType (TEXT 50) that includes this
list:
Initial Assessment
Lesson
Self-Practice
Typing Tutorial
Cancellation
and
BillCategories, with a column, BillCategory (TEXT 20) that includes this
list:
Supplies
OtherExpenses
Self-Practice
Typing Tutorial
Mileage
If I issue the statement:
SELECT BillCategory FROM BillCategories WHERE BillCategory IN (SELECT
ServiceType FROM ServiceTypes)
It correctly returns the values,
Self-Practice
Typing Tutorial
BUT, if I do the reverse of this statement and type:
SELECT ServiceType FROM ServiceTypes WHERE ServiceType IN (SELECT
BillCategory FROM BillCategories)
I get a "No Rows Exist ..." message.
If I refine it and type:
SELECT ServiceType FROM ServiceTypes WHERE ServiceType = 'self-practice' AND
ServiceType IN (SELECT BillCategory FROM BillCategories)
It correctly returns 'Self-Practice'
Apparently it's the difference in data length - It works if I type:
SELECT ServiceType FROM ServiceTypes WHERE (SGET(ServiceType,20,1)) IN
(SELECT BillCategory FROM BillCategories)
It seems to me that "Self-Practice" = "Self-Practice" regardless of the size
of the data field.
Sami
-----------------------------------------------------------
Sami Aaron
Software Management Specialists
19312 W 63rd Terr
Shawnee KS 66218
913-915-1971
http://www.softwaremgmt.com
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
