i am trying to build a query in sql that compares between 2 tables one
hold to field and the other hold the 2 fields in one
example:
table1:EN,12
table2:EN.12
how can i compare between the tables throw that field
i try with this query but it doesnt work:
SELECT * FROM dbo.CNT_DOC_LANGS x INNER JOIN dbo.CNT_DOCS2QUEST y ON
(CAST(x.DOC_ID AS varchar) + '.' + RTRIM(x.LANG)) t = y.SRC_ID
please help