Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

how to convert this into a linkSQL statement?

May 25, 2005, 4:00 AM
ryel01
Veteran (1264 posts)
May 25, 2005, 4:00 AM
Views: 3281
Shortcut
Quote Reply
how to convert this into a linkSQL statement?
Hi

I need to convert this into some code for linkSQL but am having some trouble. It's actually the mysql answer to what I need to do in another post I made - but I can't edit that post for some reason... who knows.

This is the mysql version that I need to translate into linkSQL code...

Code:
select * from lsql_easy_pol, lsql_easy_relations where lsql_easy_pol.pol_id = lsql_easy_relations.pol_id_fk;

then I also need this too...

Code:
select * from lsql_easy_pol, lsql_easy_relations where lsql_easy_pol.pol_id != lsql_easy_relations.pol_id_fk;

The only difference between them is the "!=" vs "=" when matching the columns.

Can anyone help with this one?

Thanks!
Subject Author Views Date
Thread how to convert this into a linkSQL statement? ryel01 3281 May 25, 2005, 4:00 AM
Thread Re: [ryel01] how to convert this into a linkSQL statement? 		Andy 3256 May 25, 2005, 4:21 AM
Thread Re: [Andy] how to convert this into a linkSQL statement? 		ryel01 3220 May 25, 2005, 5:36 AM
Thread Re: [ryel01] how to convert this into a linkSQL statement? 		Andy 3216 May 25, 2005, 6:14 AM
Thread Re: [Andy] how to convert this into a linkSQL statement? 		fuzzy logic 3194 May 25, 2005, 7:41 AM
Post Re: [fuzzy logic] how to convert this into a linkSQL statement? 		ryel01 3187 May 25, 2005, 3:10 PM
Thread Re: [Andy] how to convert this into a linkSQL statement? 		ryel01 3190 May 25, 2005, 3:39 PM
Post Re: [ryel01] how to convert this into a linkSQL statement? 		Andy 3170 May 25, 2005, 11:24 PM