HI all,
i need tow basic clarifications
1. If i used nested while select statement ( multiple times ) instead of join , So, what will create a problem in the future? like performance issues in PROD server.
example -- while select field1, filed 2 from table name
{
while select field1, field2, filed3 from table 2
where table2,accountnum == table1.accountnum
{
if(table2.recid)
{
// todo
}
}
}
2.QBDS is always preferable t o use?
kindly confirm
