I would like to ask for performance of SQL. This is my query:
Select
A.code
,A.name
,(Select
B.price
From B
Where B.card = A.card
And B.quote = A.quote)
,(Select
B.quantity
From B
Where B.card = A.card
And B.quote = A.quote)
From A
Where A.flag = '0'
And A.date = '2016/09/02'
Something like this. Is it good performance query? Is will slow if data will big amount. How should I make query for more good performance?
Sorry for my poor English and thanks in advance
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)