You need to sign in to do that
Don't have an account?
Akshay Shrivastava
soql quiery in apex
Quiery1= 'select Required_car__c,Email from Lead where Status = Car Not Available';
Quiery2='select Car_Details_c from Available_c';
Now I want
Quiery3= Required_car__c==Car_details__c
can anyone help
Quiery2='select Car_Details_c from Available_c';
Now I want
Quiery3= Required_car__c==Car_details__c
can anyone help
The mentioned details is not clear can you elaborate the scenario?
Thanks.
then I want that value in a query
Whay is relation ship between Available_c and Lead , after that we will able to solve it
Regards
there is no relationship.
Is it neccessary to have a relationship?
Greeting!
If it is not mandatory to have Query3 what you can do is,
Quiery2='select Car_Details_c from Available_c';
Quiery1= 'select Required_car__c,Email from Lead where Status = Car Not Available' and Required_car__c=Car_Details_c;
If you find your solution mark this as the best answer.
Thank you!
Regards,
Suraj Tripathi
Try this
select Required_car__c,Email from Lead where Status = 'Car Not Available' and Required_car__c IN (select Car_Details_c from Available_c)
Please go with concept
you are using two buject Lead and Available_c how to possible to fetch and compare without releationship. Please check and let me know if you have any doubt
if you need any assistanse, Please let me know!!
Kindly mark my solution as the best answer if it helps you.
Thanks
Mukesh