connect 2 different columns from 2 tables

[tabakaka]

i need to connect 2 different columns from 2 tables.

note the these columns are strings (varchar)

column on 1st table: description1
column on 2nd table: description2

example:
description1: corporate unit staff
description2: corporate unit staff/division head/finance

i did some string manipulation.
variable.ToString.Substring(0, (DataTable.Rows(0)("description2")).ToString.Index Of("/"))

how do i connect these tables using inner join in sql or code behind?

[dip_developer]

i need to connect 2 different columns from 2 tables.

note the these columns are strings (varchar)

column on 1st table: description1
column on 2nd table: description2

example:
description1: corporate unit staff
description2: corporate unit staff/division head/finance

i did some string manipulation.
variable.ToString.Substring(0, (DataTable.Rows(0)("description2")).ToString.Index Of("/"))

how do i connect these tables using inner join in sql or code behind?

Dont you want to join these two tables on any primary key??
if not then simply use the UNION operator....like

SELECT description1 FROM table1
UNION
SELECT description2 FROM table2

Note: This command cannot be used to list all descrition in table1 and table2. If there is description with the same name then only one will be listed. The UNION command only selects distinct values.

If you want all values then use UNION ALL operator like.....

SELECT description1 FROM table1
UNION ALL
SELECT description2 FROM table2

is this the answer you want??? let us know.

[tabakaka]

Dont you want to join these two tables on any primary key??
if not then simply use the UNION operator....like

SELECT description1 FROM table1
UNION
SELECT description2 FROM table2

Note: This command cannot be used to list all descrition in table1 and table2. If there is description with the same name then only one will be listed. The UNION command only selects distinct values.

If you want all values then use UNION ALL operator like.....

SELECT description1 FROM table1
UNION ALL
SELECT description2 FROM table2

is this the answer you want??? let us know.

not exactly the answer im looking for.

my main concern is AFTER the string manipulation. i couldnt join the two tables because they give different values like ive mentioned earlier. so i need to do string manipulation first for Description2 to connect them

[Shashi Sadasivan]

not exactly the answer im looking for.

my main concern is AFTER the string manipulation. i couldnt join the two tables because they give different values like ive mentioned earlier. so i need to do string manipulation first for Description2 to connect them

On what basis do you want to connect the 2 tables?

[dip_developer]

not exactly the answer im looking for.

my main concern is AFTER the string manipulation. i couldnt join the two tables because they give different values like ive mentioned earlier. so i need to do string manipulation first for Description2 to connect them

what type of string manipulation you want......be more specific.......give some example if possible....

[tabakaka]

what type of string manipulation you want......be more specific.......give some example if possible....

1st table has column1 that contains a value, Corporate
2nd table has column2 that contains a value, Corporate/staff/unit

pac2 = pac.ToString.Substring(0, pac.ToString.IndexOf("/"))
 

after the manipulation of the string in column2, it results to "Corporate" which is the basis for the connection of the two tables.

how do i connect these two tables using sql or code behind. also, i have 3 more tables to connect with. so the use of inner join is, i think, imperative.

[tabakaka]

On what basis do you want to connect the 2 tables?

the string. the other table doesnt have a primary. so i have to base on the string (varchar) instead. which the columns of these 2 tables are different. i only need the string before the slash ("/") to connect these

[Shashi Sadasivan]

the string. the other table doesnt have a primary. so i have to base on the string (varchar) instead. which the columns of these 2 tables are different. i only need the string before the slash ("/") to connect these

Still not sure what you are looking for!
any examples?
from what i can figure out, you want to output 2 columns, and show the columns from the second table whose field starts with the string of field of the first table.

select t1.c1, t2.c1 from table1 t1, table2 t2
where t1.c1 like concat('%',t1.c1,'%')

[tabakaka]

Still not sure what you are looking for!
any examples?
from what i can figure out, you want to output 2 columns, and show the columns from the second table whose field starts with the string of field of the first table.

select t1.c1, t2.c1 from table1 t1, table2 t2
where t1.c1 like concat('%',t1.c1,'%')

i tried the code u gave me. there was an error.

i want to connet these 2 tables based on a string data type.

column1 in table1 = corporate
column2 in table2 = corporate/staff/unit

i did a string manipulation in column2. so it becomes "corporate". this is for the connection of table1 to table2. the problem is, how do i join them with the other 3 tables. will i use inner join or just code it in code behind?

[dip_developer]

i tried the code u gave me. there was an error.

i want to connet these 2 tables based on a string data type.

column1 in table1 = corporate
column2 in table2 = corporate/staff/unit

i did a string manipulation in column2. so it becomes "corporate". this is for the connection of table1 to table2. the problem is, how do i join them with the other 3 tables. will i use inner join or just code it in code behind?

still very confusing...why dont you use three different fields for corporate,staff and unit in the second table....???