I need someone who understandas SQL better then me
what I am trying to do is compare tables from my local database to my remote database
The Remote database has tables that have lots of feilds in but for the local database do not need all the feilds
so I am using this
Code: Select all
$Query = Null
$Query &= "Select "
$Query &= "idnumber, "
$Query &= "refusaldescription "
$Query &= "from " & Global.$DBCon & ".agerefusallist "
$Query &= "Where refusaldescription NOT IN "
$Query &= "(Select "
$Query &= "idnumber, "
$Query &= "refusaldescription "
$Query &= "from " & Global.$DBConLocal & ".agerefusallist);"
Am i even on the right tack or am I completely loosing the plot?