Dan,
SELECT ResourceTable.* FROM ResourceTable
LEFT JOIN ResourceLinkTable
ON ResourceTable.ResourceID = ResourceLinkTable.ResourceID
WHERE ResourceLinkTable.ResourceID IS NULL;
Regards,
Thomas
On Thu, 30 Oct 2003, Dan Lamb wrote:
> Hello All,
>
> I have two table the look like thi
Adam
-Original Message-
From: Dan Lamb [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 9:39 AM
To: [EMAIL PROTECTED]
Subject: select query syntax help
Hello All,
I have two table the look like this (greatly simplified):
ResourceTable
-
int ResourceID
var Resourc
Hello All,
I have two table the look like this (greatly simplified):
ResourceTable
-
int ResourceID
var ResourceName
ResourceLinkTable
-
int ResourceLinkID
int ResourceID
var Text
I need to find all rows in ResourceTable for which there is NO entry in
ResourceLin
CTED]]
Sent: den 30 maj 2001 15:09
To: [EMAIL PROTECTED]
Subject: Servlet SELECT Query syntax error
Hi
Error message "You have error in your SQL syntax" ... Using Apache Tomcat -
MySQL in Win 2000.
Scenario: Servlet collects form data value, sends query to MySQL, returns
search. The problem
Hi
Error message "You have error in your SQL syntax" ... Using Apache Tomcat -
MySQL in Win 2000.
Scenario: Servlet collects form data value, sends query to MySQL, returns
search. The problem is getting
the value of the inputted parameter named, title_name. Problem coding:
rs = stmt.executeQue
no , i havn't any key with AUTO_INCREMENT option
i wont numbered my rows on fly! how to do it.
pleease help me!!!
RT> supposed you numbered all rows in the table incrementally in field nid:
RT> select mydata from mytable where mod(nid, N)=offset;
RT> fill in N and offset (0..n-1)
RT> On Sat, 28
supposed you numbered all rows in the table incrementally in field nid:
select mydata from mytable where mod(nid, N)=offset;
fill in N and offset (0..n-1)
On Sat, 28 Apr 2001 14:26:46 +0400
Igor V Yermakov <[EMAIL PROTECTED]> wrote:
> i have 400 rows in my mysql database table
> and i wont ge
i have 400 rows in my mysql database table
and i wont get each N row from table (say each sixth row)???
please help me???
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c