by Aditi Corporati » Fri, 25 Jul 1997 04:00:00
Hi Jonathan,
Try this sql statement.
SELECT * FROM [Table Name] WHERE Like "*My brother's brother*"
Hope this helps you,
Venkatesh S
Aditi Corp.
http://www.aditi.com
Visit our FAQ Page At : http://www.aditi.com/knowledge/vb/index.html
Aditi Corp was formerly known as NetQuest Inc.
1. Accessing data from a 'brother' file
Relationships:
A--B--C
|
D
I run a report on B so I can retrieve data from A & C.
However, I also want to retrieve data from D.
B has no common fields with D.
A can be linked to D though.
How do I retrieve info. from D by B ???
3. Brother's Keeper and btrieve?
4. trouble with single space with oracle UTF8 database
5. SQL for "My brother's brother"
9. How to SendUserEvent to 'brother' frame ???
10. Separate 'StringName' into 'Last', 'First', 'Middle'
11. How set parameters for 'Select * from Suppliers where SuppID in ('111', '222', '333')'