RE: LEFT JOIN trouble. Please help.

2001-12-13 Thread Ján Fedorek
-Original Message- From: Aleksandar Bradaric [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 3:32 PM To: Ján Fedorek Cc: MySQL List Subject: Re: LEFT JOIN trouble. Please help. Hi, > I have two tables and I want create third one with LEFT JOIN > First table

Re: LEFT JOIN trouble. Please help.

2001-12-12 Thread Aleksandar Bradaric
Hi, > I have two tables and I want create third one with LEFT JOIN > First table table1 containts field AA as a primary key (AA is NOT NULL). > Second table table2 containts field AA as a primary key (AA is NOT NULL) > too. > Ex: > CREATE TABLE a (PRIMARY KEY(AA)) > SELECT table1.AA FROM table2