Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

how to convert this into a linkSQL statement?

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 2598 May 25, 2005, 4:00 AM
Thread Re: [ryel01] how to convert this into a linkSQL statement?
Andy 2534 May 25, 2005, 4:21 AM
Thread Re: [Andy] how to convert this into a linkSQL statement?
ryel01 2537 May 25, 2005, 5:36 AM
Thread Re: [ryel01] how to convert this into a linkSQL statement?
Andy 2531 May 25, 2005, 6:14 AM
Thread Re: [Andy] how to convert this into a linkSQL statement?
fuzzy logic 2510 May 25, 2005, 7:41 AM
Post Re: [fuzzy logic] how to convert this into a linkSQL statement?
ryel01 2511 May 25, 2005, 3:10 PM
Thread Re: [Andy] how to convert this into a linkSQL statement?
ryel01 2505 May 25, 2005, 3:39 PM
Post Re: [ryel01] how to convert this into a linkSQL statement?
Andy 2493 May 25, 2005, 11:24 PM