vegnadragon Posted January 23, 2008 Share Posted January 23, 2008 Is there anyway to select all expect some, like select * from where id not = 2, or something like that Quote Link to comment Share on other sites More sharing options...
wsantos Posted January 23, 2008 Share Posted January 23, 2008 Yes. SELECT * FROM table WHERE ID != variable; or SELECT * FROM table1 WHERE ID NOT IN (SELECT * FROM table2) .... and many more Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.