Posted by filipwitczak on 10/01/07 15:54

I have a problem - I need to select fields from two tables, where
field form table1 contains text + table2.id + text.

I have table reservations which has clients field. clients contains
client's id (taken from table2) with client's options. It's syntax is
like

|61=[49!130]&[50!15]|62=[49!130]&[50!15]|
where each |client.id=[option.id!value]&[option.id!value]|

the problem is that I need to secect specific reservation which
contains a client's data within one select statement.

So, I thought that it will be like

select * from reservations,clients where reservations.clients like
'%|' + client.id +'='

but I do not know sql so good to solve the probem and I do not know
how to google it (my native language is polish so every query I did to
google gave me carp results)


I would be grateful for any help.

regards
Filip W.

• Next in forum: Re: How to select fields form two tables, where one is containing some text+field form other table+some text
• Prev in forum: Re: Whats the most portable way to identify field existence?
• Thread view: How to select fields form two tables, where one is containing some text+field form other table+some text

[Reply to this message]