Bob,

Thanks for your great support.

Actually, i couldn't state the problems perfectly.

Each Accounts_ID will relate to a value of a table. This will be basically GL_Accounts_ID for generating Auto Voucher. Whenever...

Bob,

If u insert the following data

INSERT INTO A

SELECT 4,1,'TABLE_2','COLUMN_1',678

INSERT INTO A

SELECT 4,2,'TABLE_2','COLUMN_2',6789

INSERT INTO A

SELECT 4,3,'TABLE_2','COLUMN_3',67890

Your Query will return both 2 and 4.

But actually the expected return is "2", as...

Exactly Bob. Thats what i want.

Actually Each Accounts_ID will be associated with value from different tables. And Some tables has 1 PK, Some 2 or more. So i will...

You may have Customer_Created_Date in Customer table. And you have Sales_Date in Sales Table.

You can use

SELECT COUNT(Customer_ID) FROM Customer

WHERE Customer_Created_Date BETWEEN Sales_Date_1 AND Sales_Date_2

For Sales_Date_1 and 2, you...

I will Pass the following two rows

1,'TABLE_1','COLUMN_1',123

2,'TABLE_1','COLUMN_2',1234

to get "2" (Accounts_ID, 1st column in table A)