Skip to Content
0
Jan 18, 2008 at 09:00 AM

generate query at a time & connect two database ?

21 Views

Hi

Could u help me? it is necessary that

I have two database ( RSHPL,RSPL) and both data base have same table name and same fieldname (Table Name :-OITM, Fieldname :ONHAND ,pk- ITEMcode,)

At first I tell u what I want?

I want to generate query at a time & connect two database and same table name(OITM) to select the TOTAL VALUE of this field(ONHAND) and pk-key is Itemcode.

Is it Possible? If Possible plz write this query and send me.