|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
06-10-2007, 12:25 AM
| #1 | ||
 |
Hi all What is wrong with this syntax please...I get the error "Unknown table 'tbldiabtest' in MULTI DELETE" DELETE FROM tbldiabtest USING tbldiabtest t1, tblPat_sys t2 WHERE t1.pat_sys = t2.pat_sys; Thanks | ||
     |
|
06-10-2007, 12:25 AM
| #2 | ||
| |
Just got it to work..but thanks anyway... "Dale" <dale@nospam.com> wrote in message news:RPMHg.14519$395.11221@edtnps90... > Hi all > What is wrong with this syntax please...I get the error "Unknown table > 'tbldiabtest' in MULTI DELETE" > > DELETE FROM tbldiabtest USING tbldiabtest t1, tblPat_sys t2 > WHERE t1.pat_sys = t2.pat_sys; > Thanks > | ||
| |
| Featured Websites | ||||
|
|
| Tags: delete, syntax |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| DELETE query | Nel | Database | 1 | 06-10-2007 12:19 AM |
| amazing syntax error | Hilarion | Database | 1 | 06-10-2007 12:18 AM |
| amazing syntax error | Oli Filth | Database | 0 | 06-10-2007 12:18 AM |
| IF THEN ELSE syntax | mzi | Database | 0 | 05-31-2007 8:47 PM |
| Can't delete song | VovaM | Windows | 2 | 01-23-2007 10:10 AM |
| Featured Websites | ||||
|
Delete syntax 
PacMan
Linear Mode
