On Jan 25, 2007, at 11:46 AM, Kai Schlamp wrote:
What is the best way to find out the relationship of two columns in a
table?
I want to know if it is 1:1, 1:N, or M:N. Is there an easy way to do
this with a SQL statement?
If both tables have the same rowcount, and SELECT count(*) FROM a
JOIN
Hello!
What is the best way to find out the relationship of two columns in a
table?
I want to know if it is 1:1, 1:N, or M:N. Is there an easy way to do
this with a SQL statement?
Best regards,
Kai
---(end of broadcast)---
TIP 1: if posting/readin