Sanders Kaufman wrote:
> Jerry Stuckle wrote:
>
>> How about something like:
>>
>> SELECT * FROM uploads
>> JOIN uploadsOwners ON uploads.id = uploadsOwners.id
>> WHERE uploadsOwners.owner = 'john';
>
>
> Does that require Foreign Key relationship?
No, joins do not require a foreign key relationship. Foreign keys are
strictly for DELETE statements or UPDATE statements where the key is
being changed.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================