Like - Problem

2004-09-23 Thread Rui Monteiro
each word. The following syntax doesn't work: --- Select * from fruits where (fruits.color like in ('%Green%', '%Apple%') or fruits.type like in ('%Green%', '%Apple%') ----

Primary Keys

2004-07-20 Thread Rui Monteiro
Mello, I was wondering why canto r how can I put 2 primary keys on a table? Here's na example on Oracle language: CREATE TABLE FacturaMusica( CodFactura number(4), CONSTRAINTS FK_FacturaMusica_CodFactura FOREIGN KEY(CodFactura) REFERENCES Factura(CodFactura), C