Query relational tables

2003-02-15 Thread Dee
|| ++--+--+-+-++ How can I query the movie tables so that it will get the names of the actors when each actor field may have a different name or may be null? I am unable to query on more than one actor. Thanks Dee

Duplicate

2003-03-02 Thread Dee
of the QUERY does not help. Does anyone know how I can check for a duplicate in a database before adding a record. I am checking a text field for duplicate entry. Which means that I have to ignore case and spacing. Thanks for any help. Dee

Creating InnoDB tables with ansi option fails

2003-10-02 Thread M . Dee
t;A_ID") ); CREATE TABLE "B" ( "A_ID"integer, INDEX("A_ID"), FOREIGN KEY ("A_ID") REFERENCES "A" ("A_ID") ); >Fix: Unknown >Submitter-Id: