RE: [PHP] sql query and some math

2003-12-17 Thread Jay Blanchard
[snip] q1) i got a database with 2 diffrent tables, i want to take out all the information that arent duplicated from on of the tables, like this: $sql = "SELECT t1.rubrik, t1.info, t2.priser FROM table1 AS t1, table2 AS t2 WHERE t1.arkiv = '0' ORDER BY t1.rubrik"; [/snip] It's a SQL question, bu

[PHP] sql query and some math

2003-12-17 Thread Patrik Fomin
Hi, q1) i got a database with 2 diffrent tables, i want to take out all the information that arent duplicated from on of the tables, like this: $sql = "SELECT t1.rubrik, t1.info, t2.priser FROM table1 AS t1, table2 AS t2 WHERE t1.arkiv = '0' ORDER BY t1.rubrik"; the problem is that i got alot of