The 2005 FSM schematic shows that the signal from the front power window master switch to the rear windows goes through the rear window switches. So if the rear switch works by itself, it sounds like you've got a bad power window master switch there in your driver's door.
Edit: Looking at it again, it does look possible for the switch on the rear door to break in such a way that it won't pass the signal from the front switch through to the window motor, but still work correctly when operated from the back. So it might also be the rear driver-side door switch. The FSM troubleshooting procedure can also isolate that too.
According to Courtsey Nissan's site, you can't buy the individual switches and replace just the switch for the left rear window in it - you can only buy the whole assembly (see 25750 in the bottom diagram).
251 Switch :: Body Electrical :: Genuine Nissan Parts :: Frontier Parts (D40) 2005-2010 :: Nissan Parts, NISMO and Nissan Accessories - Courtesyparts.com
Fontana Nissan (a site sponsor) is about $4 cheaper ($84 vs $88 ).
Nissan Performance Aftermarket Parts | Nismo | Nissan Racing Parts
Before spending that kind of money (or surveying junkyards looking for a used one), check out the FSM yourself to see if you think my theory makes sense. It has a troubleshooting procedure to isolate the problem to the front switch to confirm that's the problem.
http://www.clubfrontier.org/forums/f23/frontier-service-manuals-available-download-46290/
Edit: Looking at it again, it does look possible for the switch on the rear door to break in such a way that it won't pass the signal from the front switch through to the window motor, but still work correctly when operated from the back. So it might also be the rear driver-side door switch. The FSM troubleshooting procedure can also isolate that too.
According to Courtsey Nissan's site, you can't buy the individual switches and replace just the switch for the left rear window in it - you can only buy the whole assembly (see 25750 in the bottom diagram).
251 Switch :: Body Electrical :: Genuine Nissan Parts :: Frontier Parts (D40) 2005-2010 :: Nissan Parts, NISMO and Nissan Accessories - Courtesyparts.com
Fontana Nissan (a site sponsor) is about $4 cheaper ($84 vs $88 ).
Nissan Performance Aftermarket Parts | Nismo | Nissan Racing Parts
Before spending that kind of money (or surveying junkyards looking for a used one), check out the FSM yourself to see if you think my theory makes sense. It has a troubleshooting procedure to isolate the problem to the front switch to confirm that's the problem.
http://www.clubfrontier.org/forums/f23/frontier-service-manuals-available-download-46290/