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.

filipwitczak [at] gmail.com wrote:
> I have a problem - I need to select fields from two tables, where
> field form table1 contains text + table2.id + text.

This is quite easy

SELECT * FROM table1
INNER JOIN table2 ON(table1.commoncolumn=table2.commoncolumn)
WHERE column='something'


> 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]|

You are using a data structure that is better fit for flat line storage of data

SQL table would look like

client_id, option_id, option_value

And you have one row for each option.

If you redesign your database, things will get a lot easier


--

//Aho