Re: [GENERAL] relationship in a table

2007-02-02 Thread Jim Nasby
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

[GENERAL] relationship in a table

2007-01-26 Thread Kai Schlamp
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