CREATE IF STATEMENT FOR 2 SQL SELECT QUERIES IN IREPORT

[ely78144]

Hello I am new in this,

I have a 2 sql select statement.

this is the first sql statement:

SELECT

     service_card.`no` AS service_card_no,

     customer.`customer_name` AS customer_customer_name,

     serial_numbers.`no` AS serial_numbers_no,

     items.`item_description` AS items_item_description,

     defect.`description` AS defect_description,

     service_card.`date_received` AS service_card_date_received,

     user.`first_name` AS user_first_name,

     user.`middle_name` AS user_middle_name,

     user.`last_name` AS user_last_name,

     service_card.`complaints` AS service_card_complaints,

     service_card.`store_name` AS service_card_store_name,

     service_card.`receipt_no` AS service_card_receipt_no,

     service_card.`date_purchased` AS service_card_date_purchased

FROM

     IF(service_card.customer)

     `customer` customer INNER JOIN `service_card` service_card ON customer.`id` = service_card.`customer_id`

     INNER JOIN `serial_numbers` serial_numbers ON service_card.`serial_no_id` = serial_numbers.`id`

     INNER JOIN `defect` defect ON service_card.`received_by` = defect.`id`

     INNER JOIN `user` user ON service_card.`received_by` = user.`id`

     INNER JOIN `items` items ON serial_numbers.`item_id` = items.`id`

WHERE

    service_card.id = $P{service_card_no}

 and service_card.`approved_by` IS NOT null

 

the second statement is this:

 

SELECT 

service_card.no as service_card_no,

service_card.customer_name as customer_customer_name,

items.item_description as items_item_description,

items.id AS serial_numbers_no,

service_card.complaints AS defect_description,

service_card.date_received as service_card_date_received,

user.first_name AS user_first_name,

user.middle_name AS user_middle_name,

user.last_name AS user_last_name,

service_card.complaints as service_card_complaints,

service_card.store_name as service_card_store_name,

service_card.receipt_no as service_card_receipt_no,

IFNULL(service_card.date_purchased,'') as service_card_date_purchased

FROM

service_card 

join `user` user on user.id = service_card.received_by

JOIN `items` items on service_card.item_id = items.id

where service_card.id=31

 

my question is how can I do the IF else statement inside the sql qeury of the ireport

 

any answers will be appreciated. thank you.

 

Eleazar Embuscado